Saving Data Historically with Temporal Tables: Part 1: Queries
Updated: 2024-06-28 15:58:26
In this article we discuss how to store data temporally in PostgreSQL. Temporal database store data in a way that allows you to see not only what the value of any column is currently, but at any point in time that your system is created to handle. In this three part series, I will aim …
The post Saving Data Historically with Temporal Tables: Part 1: Queries appeared first on Simple Talk.
Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.
In this tip, we explore how to configure mirroring for a Snowflake database to be available in Microsoft Fabric.
This article examines whether creating SQL indexes can help when deleting data from a SQL Server table.
Learn how to use Windows Copilot to write SQL code and also the differences in responses between Windows Copilot compared to Google Gemini.
In this article, we look at Python classes and how to use classes to implement reusable code encapsulating data and behavior in a single entity.
SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes less space, all while ensuring efficient access to critical data. At its core, the metadata-styled XML format runs counter to the data that SQL Server is optimized to manage. Therefore, additional features were added to SQL Server over …
The post XML Performance Tuning and Added Options appeared first on Simple Talk.
This article looks at what Azure DevOps is and what it can be used for along with key concepts and things you need to understand for Azure DevOps.
In a previous tip, SQL Server Find and Replace Values in All Tables and All Text Columns, we walked through how to replace a single value with another single value for all text columns and all tables in a database. I have a similar need, but I need to replace multiple values with new values in one column. In this tip we look at a few examples of how this can be done. 
This tip will help you understand what NULL means and different ways to handle NULL values when working with SQL Server data.
Learn about system page latch concurrency enhancements in SQL Server 2022 compared to earlier versions to reduce tempdb contention.
In this article, I share how an SQL Server filtered index solved the problem of preventing duplicates for new rows in a table. 
Learn about new features of Microsoft Fabric such as Real-Time Intelligence, Fabric Workload Development Kit, GraphQL API, AI and Copilot, Data Factory Announcements, Task Flows, and Data Functions.
Have you ever wondered how your favorite apps seem to do everything automatically, communicate with each other so smoothly, and update content in real time? Application programming interfaces, or APIs, are little but mighty messengers that are the secret to this networked world. In the world of technology, where digital interactions are the norm, Application …
The post API Monitoring- Key Metrics and Best Practices appeared first on Simple Talk.
In this article, we look at how to enable a large language model (LLM) to answer questions based on data stored in Azure SQL Database.
This article will demonstrate the step-by-step process to dynamically display the Top N and the Bottom N records in the same Power BI chart.
Using Python functions allows you to solve the problem of having to write repeated code, make code easier to understand, and reduce code complexity.
In this tip, we will create custom audit specifications using SQL and show how to attach these to an audit in SQL Server.
Microsoft Fabric is a new centralized, AI-powered cloud data platform hosted by Microsoft. It combines several services of the existing Azure Data Platform – such as Azure Data Factory – with Power BI, while also introducing new services. It’s tempting to compare Microsoft Fabric with Azure Synapse Analytics since Synapse also bundles different services together, …
The post Choosing Between the Lakehouse and Warehouse in Microsoft Fabric appeared first on Simple Talk.
In this article, we demonstrate how to effectively communicate with Developers and others to discuss implementing production changes as a team effort.
In this tip, we will provide the essential information on Exam DP-600 Implementing Analytics Solutions Using Microsoft Fabric and the appropriate study materials, including web links, books, online courses, and practice assessments to prepare for and pass the exam.
This article covers Microsoft Fabric, describing its use and capabilities.
In this article, we will look at how to perform an entire ETL process using PySpark and load data to SQL Server on a Windows virtual machine and automate with Windows Task Scheduler.
In this article, we look at an approach to create one SQL stored procedure that can handle inserts, updates, deletes, selects, and change tracking for a table.
This tip will guide you through creating your first REST API using Azure SQL database and the Microsoft Data API Builder (DAB).